package io.geekidea.boot.overduequery.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import com.fasterxml.jackson.annotation.JsonFormat;
import io.geekidea.boot.common.BaseEntity;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;

import java.io.Serial;
import java.io.Serializable;
import java.time.LocalDateTime;

@Data
@NoArgsConstructor
@TableName("tb_overduequery")
@ToString(callSuper = true)
public class OverdueQuery extends BaseEntity implements Serializable {
    @Serial
    private static final long serialVersionUID = 1L;

    @TableId(value = "id",type = IdType.AUTO)
    private Integer id;

    @TableField("storageodd")
    private String storageodd;

    @TableField("area_fk")
    private Integer areaFk;

    @TableField("store_fk")
    private Integer storeFk;

    @TableField("materialcoding")
    private String materialcoding;

    @TableField("materialsnmark")
    private String materialsnmark;

    @TableField("costprice")
    private String costprice;

    @TableField("totalmoney")
    private String totalmoney;

    @TableField("repertoryquantity")
    private String repertoryquantity;

    @TableField("libraryage")
    private String libraryage;

    @TableField("exceedtype")
    private String exceedtype;

    @TableField("materialdepot")
    private String materialdepot;

    @TableField("storageTime")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone="GMT+8",shape = JsonFormat.Shape.STRING)
    private LocalDateTime storageTime;

    @TableField(exist = false)
    private String areaName;

    @TableField(exist = false)
    private String storeName;

    @TableField(exist = false)
    private String rulesName;

    @TableField(exist = false)
    private String name;
}
